﻿
CREATE PROCEDURE [dbo].[OPM_ReturnReason_Insert]
(
	@Name  nvarchar(50),
	@Description  nvarchar(500),
	@DisplayOrder  int,
	@Published  int,
	@CreatedBy int,
	@Id int OUTPUT
)

AS


INSERT INTO dbo.[OPM_ReturnReason]
(
	[Name],
	[Description],
	[DisplayOrder],
	[Published],
	[Deleted],
	[CreatedBy],
	[UpdatedBy],
	[CreatedOn],
	[UpdatedOn],
    [ROWGUID]
)
VALUES
(
	@Name,
	@Description,
	@DisplayOrder,
	@Published,
	0,
	@CreatedBy,
	@CreatedBy,
	getdate(),
	getdate(),
    newid()
)

SET @Id = SCOPE_IDENTITY();

--#endregion


--#region StoredProcedure [dbo].[OPM_ReturnReason_Update]

/****** StoredProcedure [dbo].[OPM_ReturnReason_Update]   Date : 2011/9/29 ******/
SET ANSI_NULLS ON